{
  "properties" : { },
  "id" : "e6302e2d86904d6db7a27df1aa8aa3e9",
  "script" : null,
  "groupId" : "92361b125e4b4d18bbd0e388e049bf8e",
  "name" : "查询",
  "createTime" : 1727071021741,
  "updateTime" : 1727057781884,
  "lock" : "1",
  "createBy" : "ndmp",
  "updateBy" : "ndmp",
  "path" : "list",
  "method" : "GET",
  "parameters" : [ {
    "name" : "deviceType",
    "value" : "1",
    "description" : "",
    "required" : false,
    "dataType" : "String",
    "type" : "",
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ ]
  }, {
    "name" : "queryType",
    "value" : "2",
    "description" : "",
    "required" : false,
    "dataType" : "String",
    "type" : "",
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ ]
  }, {
    "name" : "ip",
    "value" : null,
    "description" : null,
    "required" : false,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  }, {
    "name" : "name",
    "value" : null,
    "description" : null,
    "required" : false,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  } ],
  "options" : [ ],
  "requestBody" : "",
  "headers" : [ ],
  "paths" : [ ],
  "responseBody" : "{\n    \"status\": 200,\n    \"message\": \"success\",\n    \"data\": {\n        \"total\": 143,\n        \"current\": 1,\n        \"size\": 30,\n        \"records\": [\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610000\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"0\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161000000000780\",\n                \"instalPlaceId\": \"07126100000909\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"10.61.250.1\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"陕西省调接入网省调核心路由器1\",\n                \"operateDate\": \"2018-03-28 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610000\",\n                \"posPortNum\": \"0\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"0\",\n                \"serialNo\": \"210235A1G4X177000029\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610000_00616100000027_2024-05-17 15:22:50\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2021-03-28 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010000036500000003\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"陕西省调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"1\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"\",\n                \"dccId\": \"0021610000\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161000000000781\",\n                \"instalPlaceId\": \"07126100000905\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"10.61.250.2\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010047310009054\",\n                \"name\": \"陕西省调接入网省调核心路由器2\",\n                \"operateDate\": \"2014-10-30 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610000\",\n                \"posPortNum\": \"\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"\",\n                \"serialNo\": \"2102351930P0D7000029\",\n                \"serNum\": \"\",\n                \"stamp\": \"610000_00616100000027_2024-05-17 15:52:55\",\n                \"twomNum\": \"\",\n                \"warrantyPeriod\": \"2017-10-30 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010047300000001\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"陕西省调\",\n                \"modelName\": \"NE40E-X8\",\n                \"orgName\": \"\",\n                \"rowId\": \"2\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610000\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"0\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161000000000782\",\n                \"instalPlaceId\": \"07126100000858\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"10.61.250.26\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"陕西省调接入网备调核心路由器\",\n                \"operateDate\": \"2018-05-08 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610000\",\n                \"posPortNum\": \"0\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"0\",\n                \"serialNo\": \"210235A1G4X177000011\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610000_00616100000027_2024-05-17 15:25:03\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2021-05-08 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010000036500000003\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"陕西省调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"3\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610000\",\n                \"deviceUNum\": \"0\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"0\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161000000000783\",\n                \"instalPlaceId\": \"07126100000910\",\n                \"instalUPos\": \"4\",\n                \"ip\": \"4.61.0.3\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"骨干网一平面陕西省调路由器\",\n                \"operateDate\": \"2021-07-05 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610000\",\n                \"posPortNum\": \"0\",\n                \"powerNum\": \"0\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"0\",\n                \"serialNo\": \"210235A1G4X187000007\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610000_00616100000027_2024-05-17 15:27:21\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2013-03-08 00:00:00\",\n                \"isKey\": \"1\",\n                \"cpuModelId\": \"7101001499010000036500000003\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"陕西省调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"4\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610000\",\n                \"deviceUNum\": \"0\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"0\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161000000000784\",\n                \"instalPlaceId\": \"07126100000916\",\n                \"instalUPos\": \"6\",\n                \"ip\": \"2.61.0.3\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"骨干网二平面陕西省调路由器\",\n                \"operateDate\": \"2021-07-05 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610000\",\n                \"posPortNum\": \"0\",\n                \"powerNum\": \"0\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"0\",\n                \"serialNo\": \"210235A1G4X186000001\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610000_00616100000027_2024-05-17 15:30:04\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2012-11-12 00:00:00\",\n                \"isKey\": \"1\",\n                \"cpuModelId\": \"7101001499010000036500000003\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"陕西省调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"5\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"\",\n                \"dccId\": \"0021610900\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161090000000799\",\n                \"instalPlaceId\": \"07126109000243\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"192.160.0.254\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009022\",\n                \"name\": \"安康地调第二接入网核心路由器\",\n                \"operateDate\": \"2010-10-01 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610900\",\n                \"posPortNum\": \"\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"\",\n                \"serialNo\": \"无\",\n                \"serNum\": \"\",\n                \"stamp\": \"610900_00616109000001_2024-05-23 17:13:19\",\n                \"twomNum\": \"\",\n                \"warrantyPeriod\": \"2011-10-01 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010141600001356\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"安康地调\",\n                \"modelName\": \"[修正]SR6608\",\n                \"orgName\": \"\",\n                \"rowId\": \"6\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"\",\n                \"dccId\": \"0021610900\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161090000000800\",\n                \"instalPlaceId\": \"07126109000261\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"61.2.96.3\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"安康地调接入网核心路由器1\",\n                \"operateDate\": \"2010-10-01 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610900\",\n                \"posPortNum\": \"\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"\",\n                \"serialNo\": \"无\",\n                \"serNum\": \"\",\n                \"stamp\": \"610900_00616109000001_2024-05-23 17:13:00\",\n                \"twomNum\": \"\",\n                \"warrantyPeriod\": \"2011-10-01 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010141600001356\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"安康地调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"7\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"\",\n                \"dccId\": \"0021610900\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161090000000801\",\n                \"instalPlaceId\": \"07126109000261\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"61.2.96.3\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"安康地调接入网核心路由器2\",\n                \"operateDate\": \"2010-10-01 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610900\",\n                \"posPortNum\": \"\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"\",\n                \"serialNo\": \"无\",\n                \"serNum\": \"\",\n                \"stamp\": \"610900_00616109000001_2024-05-23 17:09:38\",\n                \"twomNum\": \"\",\n                \"warrantyPeriod\": \"2011-10-01 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010141600001356\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"安康地调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"8\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"\",\n                \"dccId\": \"0021610900\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161090000000802\",\n                \"instalPlaceId\": \"07126109000213\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"61.4.65.3\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"安康地调第二接入网备调核心路由器\",\n                \"operateDate\": \"2013-04-26 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610900\",\n                \"posPortNum\": \"\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"\",\n                \"serialNo\": \"无\",\n                \"serNum\": \"\",\n                \"stamp\": \"610900_00616109000001_2024-05-23 17:15:40\",\n                \"twomNum\": \"\",\n                \"warrantyPeriod\": \"2014-04-26 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010141600001356\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"安康地调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"9\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610900\",\n                \"deviceUNum\": \"0\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"0\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161090000000803\",\n                \"instalPlaceId\": \"07126109000213\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"61.2.96.3\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"安康地调接入网备调核心路由器\",\n                \"operateDate\": \"2013-04-26 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610900\",\n                \"posPortNum\": \"0\",\n                \"powerNum\": \"0\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"0\",\n                \"serialNo\": \"无\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610900_00616109000001_2024-05-23 16:54:57\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2014-04-26 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010141600001356\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"安康地调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"10\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610900\",\n                \"deviceUNum\": \"0\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"0\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161090000000804\",\n                \"instalPlaceId\": \"07126109000242\",\n                \"instalUPos\": \"9\",\n                \"ip\": \"61.2.96.1\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"骨干网一平面陕西安康路由器\",\n                \"operateDate\": \"2023-07-12 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610900\",\n                \"posPortNum\": \"0\",\n                \"powerNum\": \"0\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"0\",\n                \"serialNo\": \"无\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610900_00616109000001_2024-05-23 16:47:02\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010141600001356\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"安康地调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"11\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610900\",\n                \"deviceUNum\": \"0\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"0\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161090000000805\",\n                \"instalPlaceId\": \"07126109000241\",\n                \"instalUPos\": \"9\",\n                \"ip\": \"61.2.65.2\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"骨干网二平面陕西安康路由器\",\n                \"operateDate\": \"2010-12-01 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610900\",\n                \"posPortNum\": \"0\",\n                \"powerNum\": \"0\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"0\",\n                \"serialNo\": \"无\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610900_00616109000001_2024-05-23 16:53:34\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2013-12-01 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010141600001356\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"安康地调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"12\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610300\",\n                \"deviceUNum\": \"16\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"9\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161030000000842\",\n                \"instalPlaceId\": \"07126103000205\",\n                \"instalUPos\": \"6\",\n                \"ip\": \"61.2.48.1\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"宝鸡地调接入网主调核心路由器1\",\n                \"operateDate\": \"2019-01-07 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610300\",\n                \"posPortNum\": \"0\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"0\",\n                \"serialNo\": \"210235A1G4X18A000002\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610300_00616103000004_2024-05-31 14:47:02\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010000036500000003\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"宝鸡地调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"13\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610300\",\n                \"deviceUNum\": \"16\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"9\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161030000000843\",\n                \"instalPlaceId\": \"07126103000209\",\n                \"instalUPos\": \"6\",\n                \"ip\": \"61.4.40.1\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"宝鸡地调接入网主调核心路由器2\",\n                \"operateDate\": \"2009-12-09 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610300\",\n                \"posPortNum\": \"0\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"31\",\n                \"serialNo\": \"210235A0W2X2230P000H\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610300_00616103000004_2024-05-31 14:47:02\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2012-12-09 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010000036500000003\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"宝鸡地调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"14\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610300\",\n                \"deviceUNum\": \"7\",\n                \"expiryDate\": \"2021-01-27 00:00:00\",\n                \"feNum\": \"6\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161030000000844\",\n                \"instalPlaceId\": \"07126103000187\",\n                \"instalUPos\": \"5\",\n                \"ip\": \"\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009022\",\n                \"name\": \"陕西省调接入网宝鸡落地路由器1\",\n                \"operateDate\": \"2010-01-05 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610300\",\n                \"posPortNum\": \"0\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1004\",\n                \"scNum\": \"0\",\n                \"serialNo\": \"2102351930P0B6000324\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610300_00616100000102_2022-10-22 15:36:21\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2013-01-05 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"宝鸡地调\",\n                \"modelName\": \"[修正]SR6608\",\n                \"orgName\": \"\",\n                \"rowId\": \"15\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"\",\n                \"dccId\": \"0021610300\",\n                \"deviceUNum\": \"10\",\n                \"expiryDate\": \"2018-06-30 00:00:00\",\n                \"feNum\": \"4\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161030000000845\",\n                \"instalPlaceId\": \"07126103000187\",\n                \"instalUPos\": \"24\",\n                \"ip\": \"\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010047310009046\",\n                \"name\": \"陕西省调接入网宝鸡落地路由器2\",\n                \"operateDate\": \"2005-10-11 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610300\",\n                \"posPortNum\": \"\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1004\",\n                \"scNum\": \"\",\n                \"serialNo\": \"\",\n                \"serNum\": \"\",\n                \"stamp\": \"610300_00616100000102_2022-10-22 15:37:33\",\n                \"twomNum\": \"\",\n                \"warrantyPeriod\": \"2008-10-11 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"宝鸡地调\",\n                \"modelName\": \"NE08\",\n                \"orgName\": \"\",\n                \"rowId\": \"16\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610300\",\n                \"deviceUNum\": \"14\",\n                \"expiryDate\": \"2022-08-23 00:00:00\",\n                \"feNum\": \"38\",\n                \"firmwareVersion\": \"v5.70(V600R001C00SPCe00)\",\n                \"id\": \"720161030000000846\",\n                \"instalPlaceId\": \"07126103000207\",\n                \"instalUPos\": \"12\",\n                \"ip\": \"4.61.13.1\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010047310009054\",\n                \"name\": \"骨干网一平面陕西宝鸡路由器\",\n                \"operateDate\": \"2011-11-25 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610300\",\n                \"posPortNum\": \"2\",\n                \"powerNum\": \"4\",\n                \"runingState\": \"1004\",\n                \"scNum\": \"8\",\n                \"serialNo\": \"2102351930P0B6000324\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610300_00616100000102_2022-10-20 16:50:48\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2014-11-25 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"宝鸡地调\",\n                \"modelName\": \"NE40E-X8\",\n                \"orgName\": \"\",\n                \"rowId\": \"17\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"2\",\n                \"dccId\": \"0021610300\",\n                \"deviceUNum\": \"17\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"9\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161030000000847\",\n                \"instalPlaceId\": \"07126103000206\",\n                \"instalUPos\": \"11\",\n                \"ip\": \"2.61.13.1\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010047310009054\",\n                \"name\": \"骨干网二平面陕西宝鸡路由器\",\n                \"operateDate\": \"2011-11-25 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610300\",\n                \"posPortNum\": \"4\",\n                \"powerNum\": \"4\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"8\",\n                \"serialNo\": \"1023B7784200\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610300_00616103000004_2024-05-31 14:44:06\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2014-11-25 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010047300000001\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"宝鸡地调\",\n                \"modelName\": \"NE40E-X8\",\n                \"orgName\": \"\",\n                \"rowId\": \"18\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610700\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"0\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161070000000806\",\n                \"instalPlaceId\": \"07126107000184\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"255.255.255.252\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"汉中地调第一接入网主调核心路由器\",\n                \"operateDate\": \"2018-11-30 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610700\",\n                \"posPortNum\": \"0\",\n                \"powerNum\": \"0\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"0\",\n                \"serialNo\": \"无\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610700_00616107000008_2024-05-27 14:44:52\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2012-11-01 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010047300000001\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"汉中地调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"19\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610700\",\n                \"deviceUNum\": \"0\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"0\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161070000000808\",\n                \"instalPlaceId\": \"07126107000153\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"255.255.255.252\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"汉中地调第一接入网备调核心路由器\",\n                \"operateDate\": \"2009-11-01 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610700\",\n                \"posPortNum\": \"0\",\n                \"powerNum\": \"0\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"0\",\n                \"serialNo\": \"无\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610700_00616107000008_2024-05-27 11:23:00\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2012-11-01 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010047300000001\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"汉中地调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"20\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"\",\n                \"dccId\": \"0021610700\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161070000000809\",\n                \"instalPlaceId\": \"07126107000187\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"255.255.255.252\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009022\",\n                \"name\": \"汉中地调第一接入网武侯变汇聚路由器\",\n                \"operateDate\": \"2009-11-01 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610700\",\n                \"posPortNum\": \"\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"\",\n                \"serialNo\": \"无\",\n                \"serNum\": \"\",\n                \"stamp\": \"610700_00616107000008_2024-05-27 14:59:39\",\n                \"twomNum\": \"\",\n                \"warrantyPeriod\": \"2012-11-01 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010141600000184\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"汉中地调\",\n                \"modelName\": \"[修正]SR6608\",\n                \"orgName\": \"\",\n                \"rowId\": \"21\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"\",\n                \"dccId\": \"0021610700\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161070000000810\",\n                \"instalPlaceId\": \"07126107000186\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"255.255.255.252\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009022\",\n                \"name\": \"汉中地调第一接入网洋县变汇聚路由器\",\n                \"operateDate\": \"2009-11-01 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610700\",\n                \"posPortNum\": \"\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"\",\n                \"serialNo\": \"无\",\n                \"serNum\": \"\",\n                \"stamp\": \"610700_00616107000008_2024-05-27 15:05:05\",\n                \"twomNum\": \"\",\n                \"warrantyPeriod\": \"2012-11-01 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010141600000184\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"汉中地调\",\n                \"modelName\": \"[修正]SR6608\",\n                \"orgName\": \"\",\n                \"rowId\": \"22\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610700\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"0\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161070000000811\",\n                \"instalPlaceId\": \"07126107000184\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"255.255.255.252\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009022\",\n                \"name\": \"陕西省调接入网汉中落地节点路由器1\",\n                \"operateDate\": \"2010-01-05 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610700\",\n                \"posPortNum\": \"0\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"0\",\n                \"serialNo\": \"无\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610700_00616107000008_2024-05-27 16:52:55\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2013-01-05 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010141600000184\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"汉中地调\",\n                \"modelName\": \"[修正]SR6608\",\n                \"orgName\": \"\",\n                \"rowId\": \"23\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"\",\n                \"dccId\": \"0021610700\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"2018-06-30 00:00:00\",\n                \"feNum\": \"\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161070000000812\",\n                \"instalPlaceId\": \"07126107000185\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010047310009046\",\n                \"name\": \"陕西省调接入网汉中落地节点路由器2\",\n                \"operateDate\": \"2005-10-11 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610700\",\n                \"posPortNum\": \"\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1004\",\n                \"scNum\": \"\",\n                \"serialNo\": \"\",\n                \"serNum\": \"\",\n                \"stamp\": \"610000_00616100000001_2018-10-10 16:43:58\",\n                \"twomNum\": \"\",\n                \"warrantyPeriod\": \"2008-10-11 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"汉中地调\",\n                \"modelName\": \"NE08\",\n                \"orgName\": \"\",\n                \"rowId\": \"24\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610700\",\n                \"deviceUNum\": \"17\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"8\",\n                \"firmwareVersion\": \"v5.70(V600R001C00SPCe00)\",\n                \"id\": \"720161070000000813\",\n                \"instalPlaceId\": \"07126107000187\",\n                \"instalUPos\": \"9\",\n                \"ip\": \"4.61.17.1\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010047310009054\",\n                \"name\": \"骨干网一平面陕西汉中路由器\",\n                \"operateDate\": \"2011-12-05 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610700\",\n                \"posPortNum\": \"8\",\n                \"powerNum\": \"4\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"8\",\n                \"serialNo\": \"无\",\n                \"serNum\": \"0\",\n                \"stamp\": \"610700_00616107000008_2024-05-29 15:14:17\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2014-12-05 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010141600000184\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"汉中地调\",\n                \"modelName\": \"NE40E-X8\",\n                \"orgName\": \"\",\n                \"rowId\": \"25\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021610700\",\n                \"deviceUNum\": \"17\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"8\",\n                \"firmwareVersion\": \"v5.70(V600R001C00SPCe00)\",\n                \"id\": \"720161070000000814\",\n                \"instalPlaceId\": \"07126107000186\",\n                \"instalUPos\": \"9\",\n                \"ip\": \"2.61.17.1\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010047310009054\",\n                \"name\": \"骨干网二平面陕西汉中路由器\",\n                \"operateDate\": \"2011-12-01 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"610700\",\n                \"posPortNum\": \"8\",\n                \"powerNum\": \"4\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"8\",\n                \"serialNo\": \"无\",\n                \"serNum\": \"16\",\n                \"stamp\": \"610700_00616107000008_2024-05-29 15:16:36\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2014-12-01 00:00:00\",\n                \"isKey\": \"\",\n                \"cpuModelId\": \"7101001499010010141600000184\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"汉中地调\",\n                \"modelName\": \"NE40E-X8\",\n                \"orgName\": \"\",\n                \"rowId\": \"26\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"\",\n                \"dccId\": \"0021611000\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"16\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161100000000815\",\n                \"instalPlaceId\": \"07126110000396\",\n                \"instalUPos\": \"10\",\n                \"ip\": \"61.4.69.3\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010056710009102\",\n                \"name\": \"商洛地调二接入备调核心路由\",\n                \"operateDate\": \"2011-11-07 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"611000\",\n                \"posPortNum\": \"16\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"\",\n                \"serialNo\": \"M6000-8S\",\n                \"serNum\": \"\",\n                \"stamp\": \"611000_00616110000002_2024-05-28 15:29:00\",\n                \"twomNum\": \"\",\n                \"warrantyPeriod\": \"2014-11-07 00:00:00\",\n                \"isKey\": \"0\",\n                \"cpuModelId\": \"7101001499010000035700000001\",\n                \"cpuNum\": \"2\",\n                \"dccName\": \"商洛地调\",\n                \"modelName\": \"M6000-8S\",\n                \"orgName\": \"\",\n                \"rowId\": \"27\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"\",\n                \"dccId\": \"0021611000\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"18\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161100000000816\",\n                \"instalPlaceId\": \"07126110000625\",\n                \"instalUPos\": \"6\",\n                \"ip\": \"61.2.104.1\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"商洛地调接入网主调核心路由器1\",\n                \"operateDate\": \"2011-11-07 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"611000\",\n                \"posPortNum\": \"18\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"4\",\n                \"serialNo\": \"210235A1G4X17C000005\",\n                \"serNum\": \"\",\n                \"stamp\": \"611000_00616110000002_2024-05-28 15:22:14\",\n                \"twomNum\": \"\",\n                \"warrantyPeriod\": \"2014-11-07 00:00:00\",\n                \"isKey\": \"0\",\n                \"cpuModelId\": \"7101001499010000036500000001\",\n                \"cpuNum\": \"2\",\n                \"dccName\": \"商洛地调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"28\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"\",\n                \"dccId\": \"0021611000\",\n                \"deviceUNum\": \"2\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"16\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161100000000817\",\n                \"instalPlaceId\": \"07126110000626\",\n                \"instalUPos\": \"6\",\n                \"ip\": \"61.2.104.3\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010071710009100\",\n                \"name\": \"商洛地调接入网主调核心路由器2\",\n                \"operateDate\": \"2011-11-07 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"611000\",\n                \"posPortNum\": \"16\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"\",\n                \"serialNo\": \"210235A1G4X1B6000002\",\n                \"serNum\": \"\",\n                \"stamp\": \"611000_00616110000002_2024-05-28 11:47:14\",\n                \"twomNum\": \"\",\n                \"warrantyPeriod\": \"2014-11-07 00:00:00\",\n                \"isKey\": \"0\",\n                \"cpuModelId\": \"7101001499010000036500000001\",\n                \"cpuNum\": \"\",\n                \"dccName\": \"商洛地调\",\n                \"modelName\": \"SR8812-F\",\n                \"orgName\": \"\",\n                \"rowId\": \"29\"\n            },\n            {\n                \"assetNo\": \"\",\n                \"cposPortNum\": \"0\",\n                \"dccId\": \"0021611000\",\n                \"deviceUNum\": \"6\",\n                \"expiryDate\": \"\",\n                \"feNum\": \"16\",\n                \"firmwareVersion\": \"\",\n                \"id\": \"720161100000000823\",\n                \"instalPlaceId\": \"07126110000658\",\n                \"instalUPos\": \"3\",\n                \"ip\": \"192.32.3.254\",\n                \"isKernel\": \"否\",\n                \"modelId\": \"7201001499010010047310009055\",\n                \"name\": \"商洛地调-省公司三区互联路由器\",\n                \"operateDate\": \"2010-01-05 00:00:00\",\n                \"orgId\": \"\",\n                \"owner\": \"611000\",\n                \"posPortNum\": \"16\",\n                \"powerNum\": \"2\",\n                \"runingState\": \"1002\",\n                \"scNum\": \"0\",\n                \"serialNo\": \"210235FMLN0M6000137\",\n                \"serNum\": \"0\",\n                \"stamp\": \"611000_00616110000002_2024-05-28 15:22:58\",\n                \"twomNum\": \"0\",\n                \"warrantyPeriod\": \"2013-01-05 00:00:00\",\n                \"isKey\": \"0\",\n                \"cpuModelId\": \"7101001499010000036600000001\",\n                \"cpuNum\": \"2\",\n                \"dccName\": \"商洛地调\",\n                \"modelName\": \"NE40E\",\n                \"orgName\": \"\",\n                \"rowId\": \"30\"\n            }\n        ]\n    }\n}",
  "description" : "",
  "requestBodyDefinition" : {
    "name" : "",
    "value" : { },
    "description" : "",
    "required" : false,
    "dataType" : "String",
    "type" : "",
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ ]
  },
  "responseBodyDefinition" : {
    "name" : "",
    "value" : { },
    "description" : "",
    "required" : false,
    "dataType" : "String",
    "type" : "",
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ ]
  }
}
================================

sql1 = """ 
    SELECT
        nd.asset_no,
        nd.dcc_id,
        -- nd.node_id,
        -- nd.oms_id id,
        nd.device_type,
        -- nd.device_u_num,
        -- nd.firmware_version,
        -- nd.instal_u_pos,
        nd.ip,
        -- nd.mac,
        -- nd.is_kernel,
        nd.device_model_id model_id,
        nd.device_name name,
        nd.operate_date,
        nd.expiry_date,
        -- nd.warranty_period,
        nd.station_prop org_id,
        -- nd.OWNER,
        -- nd.pos_port_num,
        -- nd.cpos_port_num,
        -- nd.port_num,
        -- nd.power_num,
        -- nd.sc_num,
        -- nd.fe_num,
        -- nd.ser_num,
        -- nd.twom_num,
        -- nd.serial_no,
        -- nd.stamp,
        -- nd.mbps transmission_rate,
        mf.name  model_name,
        bd.dept_name  dcc_name,
        nd.station_name org_name
        FROM ndmp_device nd 
        LEFT JOIN blade_dept bd on nd.dcc_id = concat('00',bd.id)
        <if test="deviceType == 1 ">
            LEFT JOIN yanan.sg_aut_router_p mf on nd.device_model_id = mf.id
        </if>
        <if test="deviceType == 2">
            LEFT JOIN yanan.sg_aut_switch_p mf on nd.device_model_id = mf.id
        </if>
        where device_type = #{deviceType}
        <if test="ip !='' and ip !=null ">
            and nd.ip =#{ip}
        </if>
        <if test="name !='' and name !=null ">
            and device_name =#{name}
        </if>
 """

sql2 = """ 
    SELECT aa.*, od.name_abbreviation dcc_name, rp.name model_name,ccb.name org_name
        FROM ${tableName} aa
        LEFT JOIN yanan.sg_org_dcc_b od ON od.ID = aa.dcc_id
        <if test="tableName =='yanan.sg_aut_router_b' ">
            LEFT JOIN yanan.sg_aut_router_p rp ON rp.ID = aa.model_id
        </if>
        <if test="tableName =='yanan.sg_aut_switch_p' ">
            LEFT JOIN yanan.sg_aut_switch_p rp ON rp.ID = aa.model_id
        </if>
        -- LEFT JOIN yanan.sg_con_compcabinet_b cb ON cb.ID = aa.instal_place_id
        LEFT JOIN yanan.sg_con_commonsubstation_b  ccb  ON  ccb.ID = aa.org_id
        WHERE aa.dcc_id IS NOT NULL
        AND REGEXP_COUNT(aa.ip, '([1-9]|[1-9]\d|1\d{2}|2[0-4]\d|25[0-5])(.(\d|[1-9]\d|1\d{2}|2[0-4]\d|25[0-5])){3}')
        <if test = "ip !='' and ip !=null ">
            and ip = #{ip}
        </if>

        <if test="name !='' and name !=null ">
            and name = #{name}
        </if>
 """
if (queryType == 1) {
    //查询本地
    page = db.page(sql1)
    page.records.forEach(v -> {
        if ("1".equals(v.isKernel)) {
            v.isKernel = "是"
        } else {
            v.isKernel = "否"
        }
    });
    return page;
} else {
    if (deviceType == 1) {
        //查询路由
        tableName = "yanan.sg_aut_router_b"
    } else {
        tableName = "yanan.sg_aut_switch_b"
    }
    page = db.page(sql2)
    page.records.forEach(v -> {
        String isKernel = v.isKernel;
        if ("1".equals(v.isKernel)) {
            v.isKernel = "是"
        } else {
            v.isKernel = "否"
        }
    });
    return page
}
